SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspNews_UPDATE
(
@newsId int = null,
@title nvarchar(150) = null,
@content nvarchar(MAX) = null,
@isDeleted bit = null,
@isVisible bit = null,
@createDate datetime = null,
@lastModifiedDate datetime = null
)
AS

UPDATE
  [dbo].[News]
SET
  [Title] = @title,
  [Content] = @content,
  [IsDeleted] = @isDeleted,
  [IsVisible] = @isVisible,
  [CreateDate] = @createDate,
  [LastModifiedDate] = @lastModifiedDate
WHERE
  [NewsId] = @newsId

GO
